package com.vf.admin.client.dao;

import com.vf.admin.common.db.BaseDao;
import com.vf.admin.miaodong.entity.AppTripComment;
import com.vf.admin.miaodong.entity.AppUser;
import org.springframework.stereotype.Repository;

import java.util.ArrayList;
import java.util.List;

/**
 * <p>Title : </p>
 * <p>Description : </p>
 * <p>DevelopTools : IDEA</p>
 * <p>DevelopSystem : Windows11</p>
 *
 * @Author : zxw
 * @Date 2023/10/19 14:30
 */
@Repository
public class AppTripCommentDao extends BaseDao<AppTripComment> {


    public List<AppTripComment> getListAppTripComment(Integer tripId) {

        List<Object> paramList = new ArrayList<>();
        StringBuilder sbStr = new StringBuilder("");
        sbStr.append("SELECT * FROM app_trip_comment WHERE 1=1 and tripid  = ? ");
        paramList.add(tripId);
        sbStr.append(" order by createtime desc");
        String sql = sbStr.toString();
        return this.queryList(sql, paramList, AppTripComment.class);
    }


}
